GRASS-MySQL embedded driver

# MySQL embedded driver in GRASS

MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL embedded database without necessity to run MySQL server.

## Driver and database name

GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL embedded driver the parameter 'driver' should be set to value 'mesql'. The parameter 'database' is a full path to the directory where database tables are stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it is possible to use 3 variables:

- $GISDBASE - path to current GISBASE
- $LOCATION_NAME - name of current location
- $MAPSET - name of current mapset

Examples of connection parameters:

      db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
      db.connect driver=mesql database=/home/user1/db

## Data types, indexes

For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver

## Database type

Because database closing was found very slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb' server option).

## Note

The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second table. This can be fixed in future.

## SEE ALSO

db.connect, SQL support in GRASS GIS

## Credits

Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.

## AUTHOR

Radim Blazek

Last changed: $Date: 2007-10-28 16:03:29 -0500 (Вс, 28 окт 2007) $

Help Index